Allen The Analyst Portfolio

Data Analysts skiled in SQL, Tableau, Power BI, Phython and Excel @AllenTheAnalyst

FINANCIAL BANK LOAN DASHBOARD

Empowered decision-makers with a data-driven Power BI dashboard to proactively manage loan portfolio health and mitigate risks.

Financial Dashboard

As part of the Datasense Certificate project in June 2023, I was tasked with developing a financial dashboard using Power BI

Income Statement
And Balance Sheet

This Power BI dashboard visualizes the company's financial story (2016-2019), combining P&L and balance sheet data to track performance and financial health.

Adventure Works
End-to-End Project

Develop and implement advanced features and techniques to enhance data analysis, visualization, forecasting, pricing strategies, customer insights, and sales strategies.

WISABI BANK ATM TRANSACTION DATA ANALYTICS PROJECT

My task was to gain insights into customer behavior and ATM usage patterns by analyzing the transaction data. The goal was to identify opportunities for optimization and improvement to enhance customer satisfaction.

CUSTOMER COHORT REPORT

My task was to analyze customer retention rates, behavior, and market trends to gain insights into customer cohorts.

Sales Distribution Dashboard

Interactive Dashboard with a theme Dark & Light.

Key Insights:

  • Which month and year had the most profit?
  • Where is the company seeing the most success (by country/region)?
  • Which product and segment should the company continue to invest in?


Location

Philippines, Iloilo City

Mobile number

+639983369301

Email

allen.arorong23@gmail.com

Social